2013-02-27 - 5966.100 - Spec - Analyze performance for ROC Pricing #ROCInterface #SDSupport #US #ABAPREPORTS

SPECIFICATIONS

4678.900 - Spec - Analyze performance for ROC Pricing


Purpose

Provide technical analysis on the performance for NA_SD_ROC_PRICING_EXTRACT and ZISD_EXT_J3AP_Z020 and how it can be improved.

Admin Info

Purpose
 Provide Technical Analysis and solution to improve performance of the program
Requested By
 Steven Hayes
Spec Created By
 Surya Basa
Spec Created Date
 03/06/2013
Spec QA by
 Surya Basa
Objects
 ZISD_EXT_J3AP_Z020
Document Status
 Complete

References

Prior Tickets

None

Documents

None


Functional Requirement

Analyse the long performance time (over 20hrs) by the program ZISD_EXT_J3AP_Z020 and provide a effective solution to reduce the performance time. Change the logic to include multiple currencies and multiple Sales Organisations.



Solution Summary

[Discuss this section with Requester and get approval prior to beginning work]

1. Make changes to the existing program to enhance performance.
2. Include logic to fetch data for multiple Sales Orgs and Currencies.
3. Include currency in the selection screen.

ROC.jpg


Test Plan

[List test scenarios/cases to be executed here]
Test Scenario
 Expected Results
Run the program in background w/o any selection (open).
 The data for all the records from Tables A552 (J3AP) and A516 (Z020) should be fetched.
Run the program in background, specifying inputs for the mandatory fields- Sales Org and Season.
 The data for the specified combination of Sales Org and Currency records should be fetched
from Tables A552 and A516.
Run the program in background with varaints-combination of sales orgs and currency-
1000-USD ; 1200-AUD; 1500-MXN; 2000-USD-EUR-GBP; 3100-KRW; 4000-AUD
 The data should be fetched for the combinations specified in the varaints.
Check the file specified in the Application Server destination folder to validated the fetched records.
 The file should contain the data for o/p fields - Sales Org, Material and Currency values for J3AP
and Z020 condition types.

Solution Details

[Provide complete technical details for configuration or programming here]
The following is the analysis on Table A552 being called in the program ZISD_EXT_J3AP_Z020

1. For sales org 1000 in table A552, there are 16, 11,849 records of which 9, 26,987 are maintained in USD.
2. For sales org 2000 there are 2, 62,268 records of which 79, 017 are maintained in USD.
3. For sales org 1000 there are 9, 88,656 Materials in table MVKE of which 5, 70,753 fall under RES season.
4. There are a total of 10, 60, 535 materials in table MARA.
3. The system fetches the data from the given input parameters e.g. from sales org 1000

How is the program executing in the system?

Step1: Get the Materials related to parameters given in the selection screen -
Step2: Consider only those materials that don't have deletion indicator
Step3: Get the materials which were created in season given in the selection screen
Step4: Get the condition records from the tables A552 & A516

Recommendations/Suggestions to improve performance-

1. Include "Currency" field in the selection criteria, currently this field is hardcoded in the logic.
2. We can consider only the changed condition records to extract the material price/discounts from A552 and A516 instead of getting all the records each time the program is executed or job run. The data that was previously extracted could be updated with the changed records and all the other records remain unchanged-this could be achieved using Delta Loading (change documents).
2. Delete the condition materials/condition records that would no longer be needed.

Issues

None